# Django settings for sententialyzer project.
import sys
import os
from sqlalchemy.orm.session import sessionmaker
from sqlalchemy.engine import create_engine

DEBUG = True
TEMPLATE_DEBUG = DEBUG

DEBUG_PROPAGATE_EXCEPTIONS = True

ADMINS = (
    # ('Your Name', 'your_email@example.com'),
)

MANAGERS = ADMINS

sys.path.append(os.path.dirname(os.path.abspath(__file__)) + '/../../../lib')
#sys.path.append(os.path.dirname(os.path.abspath(__file__)) + '/../djapp')

DATABASES = {
    'default': {
        'ENGINE': '', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'sententialyzer',                      # Or path to database file if using sqlite3.
        'USER': 'sent',                      # Not used with sqlite3.
        'PASSWORD': 'sent',                  # Not used with sqlite3.
        'HOST': 'localhost',                      # Set to empty string for localhost. Not used with sqlite3.
        'PORT': '3306',                      # Set to empty string for default. Not used with sqlite3.
    }
}

DATABASE_URL = 'mysql+mysqldb://sent:sent@127.0.0.1:3306/sententialyzer?use_unicode=true&charset=utf8'

# Hosts/domain names that are valid for this site; required if DEBUG is False
# See https://docs.djangoproject.com/en/1.4/ref/settings/#allowed-hosts
ALLOWED_HOSTS = ["127.0.0.1:8000", "127.0.0.1", "localhost", "localhost:8000"]

# Local time zone for this installation. Choices can be found here:
# http://en.wikipedia.org/wiki/List_of_tz_zones_by_name
# although not all choices may be available on all operating systems.
# In a Windows environment this must be set to your system time zone.
TIME_ZONE = 'America/Chicago'

# Language code for this installation. All choices can be found here:
# http://www.i18nguy.com/unicode/language-identifiers.html
LANGUAGE_CODE = 'en-us'

SITE_ID = 1

# If you set this to False, Django will make some optimizations so as not
# to load the internationalization machinery.
USE_I18N = True

# If you set this to False, Django will not format dates, numbers and
# calendars according to the current locale.
USE_L10N = True

# If you set this to False, Django will not use timezone-aware datetimes.
USE_TZ = True

# Absolute filesystem path to the directory that will hold user-uploaded files.
# Example: "/home/media/media.lawrence.com/media/"
MEDIA_ROOT = ''

# URL that handles the media served from MEDIA_ROOT. Make sure to use a
# trailing slash.
# Examples: "http://media.lawrence.com/media/", "http://example.com/media/"
MEDIA_URL = ''

# Absolute path to the directory static files should be collected to.
# Don't put anything in this directory yourself; store your static files
# in apps' "static/" subdirectories and in STATICFILES_DIRS.
# Example: "/home/media/media.lawrence.com/static/"
STATIC_ROOT = ''

# URL prefix for static files.
# Example: "http://media.lawrence.com/static/"
STATIC_URL = '/static/'

# Additional locations of static files
STATICFILES_DIRS = (
    # Put strings here, like "/home/html/static" or "C:/www/django/static".
    # Always use forward slashes, even on Windows.
    # Don't forget to use absolute paths, not relative paths.
)

# List of finder classes that know how to find static files in
# various locations.
STATICFILES_FINDERS = (
    'django.contrib.staticfiles.finders.FileSystemFinder',
    'django.contrib.staticfiles.finders.AppDirectoriesFinder',
#    'django.contrib.staticfiles.finders.DefaultStorageFinder',
)

# Make this unique, and don't share it with anybody.
SECRET_KEY = 'qp%qlmemcri9u!8blpdw*hb6r23u=r-56f*ia_-ev62ume8!e#'

# List of callables that know how to import templates from various sources.
TEMPLATE_LOADERS = (
    'django.template.loaders.filesystem.Loader',
    'django.template.loaders.app_directories.Loader',
#     'django.template.loaders.eggs.Loader',
)

MIDDLEWARE_CLASSES = (
    'django.middleware.common.CommonMiddleware',
    #'django.contrib.sessions.middleware.SessionMiddleware',
    #'django.middleware.csrf.CsrfViewMiddleware',
    #'django.contrib.auth.middleware.AuthenticationMiddleware',
    #'django.contrib.messages.middleware.MessageMiddleware',
    # Uncomment the next line for simple clickjacking protection:
    # 'django.middleware.clickjacking.XFrameOptionsMiddleware',
)

ROOT_URLCONF = 'sententialyzer.urls'

# Python dotted path to the WSGI application used by Django's runserver.
WSGI_APPLICATION = 'sententialyzer.wsgi.application'

TEMPLATE_DIRS = (
    # Put strings here, like "/home/html/django_templates" or "C:/www/django/templates".
    # Always use forward slashes, even on Windows.
    # Don't forget to use absolute paths, not relative paths.
)

INSTALLED_APPS = (
    'sententialyzer'
#    'django.contrib.auth',
#    'django.contrib.contenttypes',
#    'django.contrib.sessions',
#    'django.contrib.sites',
#    'django.contrib.messages',
#    'django.contrib.staticfiles',
    # Uncomment the next line to enable the admin:
    # 'django.contrib.admin',
    # Uncomment the next line to enable admin documentation:
    # 'django.contrib.admindocs',
)

# A sample logging configuration. The only tangible logging
# performed by this configuration is to send an email to
# the site admins on every HTTP 500 error when DEBUG=False.
# See http://docs.djangoproject.com/en/dev/topics/logging for
# more details on how to customize your logging configuration.
LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'filters': {
        'require_debug_false': {
            '()': 'django.utils.log.RequireDebugFalse'
        }
    },
    'formatters' : {
        'formatter_sql': {
            'format': '[SQL] %(asctime)s %(message)s'
        },
        'formatter_pool': {
            'format': '[POOL] %(asctime)s %(message)s'
        }
    },
    'handlers': {
        'console':{
            'level': 'DEBUG',
            'class': 'logging.StreamHandler'
        },
        'console_sql_out':{
            'level': 'DEBUG',
            'class': 'logging.StreamHandler',
            'formatter': 'formatter_sql',
            'stream': sys.stdout
        },
        'console_pool_out':{
            'level': 'DEBUG',
            'class': 'logging.StreamHandler',
            'formatter': 'formatter_pool',
            'stream': sys.stdout
        },
        'mail_admins': {
            'level': 'ERROR',
            'filters': ['require_debug_false'],
            'class': 'django.utils.log.AdminEmailHandler'
        }
    }
}
if DEBUG:
    LOGGING['loggers'] = {
        'django.request': {
            'handlers': ['mail_admins'],
            'level': 'ERROR',
            'propagate': True,
        },
        'sent': {
            'handlers': ['console'],
            'level': 'DEBUG',
        },
        'sqlalchemy.engine': {
            'handlers': ['console_sql_out'],
            'level': 'DEBUG',
            
        },
        'sqlalchemy.pool': {
            'handlers': ['console_pool_out'],
            'level': 'DEBUG',
        }
    }
else:
    LOGGING['loggers'] = {
        'django.request': {
            'handlers': ['mail_admins'],
            'level': 'ERROR',
            'propagate': True,
        }
    }
    
DATABASE_WAIT_TIMEOUT = 120

SENTENTIALYZER_AUTHENTICATOR='sent.auth.authenticator.DummyAuthenticator'

SENTENTIALYZER_RESULT_PRINTER='sent.utils.result_printer.JSONResultPrinter'

SENTENTIALYZER_ACCESS_TOKEN_KEY='1v7XSgUu7IM3CvgX'

SENTENTIALYZER_ACCESS_TOKEN_EXPIRATION_TIME_SEC=4*60*60

#You should take special care for this user in your authenticator
SENTENTIALYZER_ADMIN_USER_NAME='sent_admin'

SENTENTIALYZER_ADMIN_GROUP_NAME='sent_admin_group'

SENTENTIALYZER_DEFAULT_GROUP_NAME='sent_default_group'

#Every user by default is in a group which has these group permissions
SENTENTIALYZER_DEFAULT_USER_GROUP_PERMISSIONS=['bopin_r', 'udat']

#If enabled insers and deletes of opinions will be delayed until
#processed in a batch every X seconds.
#This optimizes the number of updates of nested_set_left and nested_set_right values
SENTENTIALYZER_USE_DELAYED_INSERT_DELETE=True

#WARNING: rework update_opinion if you set the isolation level to REPEATABLE READ
engine = create_engine(DATABASE_URL, pool_recycle=3600, echo=DEBUG, encoding='utf-8', pool_size=10, max_overflow=300)
DbSession = sessionmaker(bind=engine)

DbSessionRO = DbSession

#isolation_level_session = DbSession()
#isolation_level_session.execute("SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;")
#isolation_level_session.close()

